Model Table PROJECT WORK BREAKDOWN STRUCTURE
Attributes
| Attribute |
Description (where applicable) |
| Company | Represents the Company connected to the project |
| Description | Represents the description of the ID column |
| ID | Id for a Project activity, Sub project or Project |
| Node Type | Represents the node type: “PROJECT”, “SUB PROJECT” or “ACTIVITY” |
| Project Id | Represents the Id for the project |
| Symbol n Description | # symbol added as prefix to the description for all rows with node type SUB PROJECT, all other rows have same value as in Description column. |
| Hierarchy |
Level |
| Work Breakdown Structure | |
| WBS01 |
| WBS02 |
| WBS03 |
| WBS04 |
| WBS05 |
| WBS06 |
| WBS07 |
| WBS08 |
| WBS09 |
| WBS10 |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| PROJECT WORK BREAKDOWN STRUCTURE | DIM_PROJ_WORK_BREAKDOWN_STRUCT_TM | DIM_PROJ_WORK_BREAKDOWN_STRUCT_BI | DIM_PROJ_WORK_BREAKDOWN_STRUCT | On Line |